SQL

how do get day of Date? eg: monday, friday

how do get day of Date? eg: monday, friday , someone asked me to explain?
SQL

If you need to get the day name (i.e. Monday, Tuesday, etc.)

select datename(weekday,getdate()) As Day_name;

Day_name
Thursday

Post your comments / questions